﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 订单管理实体类：fanli_order 。
	/// </summary>
	[Serializable]
	public class fanli_order
	{
		public fanli_order()
		{}

		#region Model
		private int _id; //id
		private int _userid; //用户id
		private int _shopID; //商城id
		private int _status; //订单状态
		private string _lianmeng; //所属联盟
		private float _fanliMoney; //返利佣金
		private int _fanliStatus; //返利状态
		private string _trade_id; //订单号
		private DateTime? _pay_time; //确认时间
		private float _commission_rate; //佣金比率
		private float _commission; //网站佣金
		private string _outer_code; //推广渠道
		private int _num_iid; //商品ID
		private string _item_title; //商品名称
		private int _item_num; //商品数量
		private float _pay_price; //成交价格
		private float _real_pay_fee; //实际支付金额
		private int _category_id; //商品类目ID
		private string _category_name; //商品类目名称
		private string _shop_title; //店铺名称
		private string _seller_nick; //卖家昵称
		private string _ext1; //扩展1
		private string _ext2; //扩展2


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 用户id
		/// </summary>
		public int userid
		{
			set{ _userid=value;}
			get{return _userid;}
		}
        /// <summary>
		/// 商城id
		/// </summary>
		public int shopID
		{
			set{ _shopID=value;}
			get{return _shopID;}
		}
        /// <summary>
		/// 订单状态
		/// </summary>
		public int status
		{
			set{ _status=value;}
			get{return _status;}
		}
        /// <summary>
		/// 所属联盟
		/// </summary>
		public string lianmeng
		{
			set{ _lianmeng=value;}
			get{return _lianmeng;}
		}
        /// <summary>
		/// 返利佣金
		/// </summary>
		public float fanliMoney
		{
			set{ _fanliMoney=value;}
			get{return _fanliMoney;}
		}
        /// <summary>
		/// 返利状态
		/// </summary>
		public int fanliStatus
		{
			set{ _fanliStatus=value;}
			get{return _fanliStatus;}
		}
        /// <summary>
		/// 订单号
		/// </summary>
		public string trade_id
		{
			set{ _trade_id=value;}
			get{return _trade_id;}
		}
        /// <summary>
		/// 确认时间
		/// </summary>
		public DateTime? pay_time
		{
			set{ _pay_time=value;}
			get{return _pay_time;}
		}
        /// <summary>
		/// 佣金比率
		/// </summary>
		public float commission_rate
		{
			set{ _commission_rate=value;}
			get{return _commission_rate;}
		}
        /// <summary>
		/// 网站佣金
		/// </summary>
		public float commission
		{
			set{ _commission=value;}
			get{return _commission;}
		}
        /// <summary>
		/// 推广渠道
		/// </summary>
		public string outer_code
		{
			set{ _outer_code=value;}
			get{return _outer_code;}
		}
        /// <summary>
		/// 商品ID
		/// </summary>
		public int num_iid
		{
			set{ _num_iid=value;}
			get{return _num_iid;}
		}
        /// <summary>
		/// 商品名称
		/// </summary>
		public string item_title
		{
			set{ _item_title=value;}
			get{return _item_title;}
		}
        /// <summary>
		/// 商品数量
		/// </summary>
		public int item_num
		{
			set{ _item_num=value;}
			get{return _item_num;}
		}
        /// <summary>
		/// 成交价格
		/// </summary>
		public float pay_price
		{
			set{ _pay_price=value;}
			get{return _pay_price;}
		}
        /// <summary>
		/// 实际支付金额
		/// </summary>
		public float real_pay_fee
		{
			set{ _real_pay_fee=value;}
			get{return _real_pay_fee;}
		}
        /// <summary>
		/// 商品类目ID
		/// </summary>
		public int category_id
		{
			set{ _category_id=value;}
			get{return _category_id;}
		}
        /// <summary>
		/// 商品类目名称
		/// </summary>
		public string category_name
		{
			set{ _category_name=value;}
			get{return _category_name;}
		}
        /// <summary>
		/// 店铺名称
		/// </summary>
		public string shop_title
		{
			set{ _shop_title=value;}
			get{return _shop_title;}
		}
        /// <summary>
		/// 卖家昵称
		/// </summary>
		public string seller_nick
		{
			set{ _seller_nick=value;}
			get{return _seller_nick;}
		}
        /// <summary>
		/// 扩展1
		/// </summary>
		public string ext1
		{
			set{ _ext1=value;}
			get{return _ext1;}
		}
        /// <summary>
		/// 扩展2
		/// </summary>
		public string ext2
		{
			set{ _ext2=value;}
			get{return _ext2;}
		}
		#endregion Model

		#region txt document
		/*
订单管理,order
id,用户id,商城id,订单状态,所属联盟,返利佣金,返利状态,订单号,确认时间,佣金比率,网站佣金,推广渠道,商品ID,商品名称,商品数量,成交价格,实际支付金额,商品类目ID,商品类目名称,店铺名称,卖家昵称,扩展1,扩展2
id,userid,shopID,status,lianmeng,fanliMoney,fanliStatus,trade_id,pay_time,commission_rate,commission,outer_code,num_iid,item_title,item_num,pay_price,real_pay_fee,category_id,category_name,shop_title,seller_nick,ext1,ext2
i,i,i,i,c20,f,i,c100,d,f,f,c100,i,c100,i,f,f,i,c100,c100,c100,c100,c100


--------------------------
-- 创建表[订单管理]开始: 
-- alter table  [fanli_order] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_order') drop table fanli_order
  CREATE TABLE [fanli_order] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [userid] int,
	 [shopID] int,
	 [status] int,
	 [lianmeng] [varchar] (20),
	 [fanliMoney] [float],
	 [fanliStatus] int,
	 [trade_id] [varchar] (100),
	 [pay_time] [datetime],
	 [commission_rate] [float],
	 [commission] [float],
	 [outer_code] [varchar] (100),
	 [num_iid] int,
	 [item_title] [varchar] (100),
	 [item_num] int,
	 [pay_price] [float],
	 [real_pay_fee] [float],
	 [category_id] int,
	 [category_name] [varchar] (100),
	 [shop_title] [varchar] (100),
	 [seller_nick] [varchar] (100),
	 [ext1] [varchar] (100),
	 [ext2] [varchar] (100)
  )

 exec sp_addextendedproperty N'MS_Description',N'订单管理 ',N'user',N'dbo',N'table',N'fanli_order', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_order',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'用户id',N'user',N'dbo',N'table',N'fanli_order',N'column',N'userid'
 exec sp_addextendedproperty N'MS_Description',N'商城id',N'user',N'dbo',N'table',N'fanli_order',N'column',N'shopID'
 exec sp_addextendedproperty N'MS_Description',N'订单状态',N'user',N'dbo',N'table',N'fanli_order',N'column',N'status'
 exec sp_addextendedproperty N'MS_Description',N'所属联盟',N'user',N'dbo',N'table',N'fanli_order',N'column',N'lianmeng'
 exec sp_addextendedproperty N'MS_Description',N'返利佣金',N'user',N'dbo',N'table',N'fanli_order',N'column',N'fanliMoney'
 exec sp_addextendedproperty N'MS_Description',N'返利状态',N'user',N'dbo',N'table',N'fanli_order',N'column',N'fanliStatus'
 exec sp_addextendedproperty N'MS_Description',N'订单号',N'user',N'dbo',N'table',N'fanli_order',N'column',N'trade_id'
 exec sp_addextendedproperty N'MS_Description',N'确认时间',N'user',N'dbo',N'table',N'fanli_order',N'column',N'pay_time'
 exec sp_addextendedproperty N'MS_Description',N'佣金比率',N'user',N'dbo',N'table',N'fanli_order',N'column',N'commission_rate'
 exec sp_addextendedproperty N'MS_Description',N'网站佣金',N'user',N'dbo',N'table',N'fanli_order',N'column',N'commission'
 exec sp_addextendedproperty N'MS_Description',N'推广渠道',N'user',N'dbo',N'table',N'fanli_order',N'column',N'outer_code'
 exec sp_addextendedproperty N'MS_Description',N'商品ID',N'user',N'dbo',N'table',N'fanli_order',N'column',N'num_iid'
 exec sp_addextendedproperty N'MS_Description',N'商品名称',N'user',N'dbo',N'table',N'fanli_order',N'column',N'item_title'
 exec sp_addextendedproperty N'MS_Description',N'商品数量',N'user',N'dbo',N'table',N'fanli_order',N'column',N'item_num'
 exec sp_addextendedproperty N'MS_Description',N'成交价格',N'user',N'dbo',N'table',N'fanli_order',N'column',N'pay_price'
 exec sp_addextendedproperty N'MS_Description',N'实际支付金额',N'user',N'dbo',N'table',N'fanli_order',N'column',N'real_pay_fee'
 exec sp_addextendedproperty N'MS_Description',N'商品类目ID',N'user',N'dbo',N'table',N'fanli_order',N'column',N'category_id'
 exec sp_addextendedproperty N'MS_Description',N'商品类目名称',N'user',N'dbo',N'table',N'fanli_order',N'column',N'category_name'
 exec sp_addextendedproperty N'MS_Description',N'店铺名称',N'user',N'dbo',N'table',N'fanli_order',N'column',N'shop_title'
 exec sp_addextendedproperty N'MS_Description',N'卖家昵称',N'user',N'dbo',N'table',N'fanli_order',N'column',N'seller_nick'
 exec sp_addextendedproperty N'MS_Description',N'扩展1',N'user',N'dbo',N'table',N'fanli_order',N'column',N'ext1'
 exec sp_addextendedproperty N'MS_Description',N'扩展2',N'user',N'dbo',N'table',N'fanli_order',N'column',N'ext2'

-- 创建表[订单管理]结束。 
--------------------------

		*/
		#endregion document
	}
}

